Skip Headers

Oracle® Database Backup and Recovery Reference 10g Release 2 (10.2) Part Number B14194-03 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# CREATE CATALOG

Syntax

createCatalog::=

Description of the illustration createcatalog.gif

Purpose

To create a schema for the recovery catalog. Typically, you create this schema in a separate recovery catalog database. The catalog is created in the default tablespace of the recovery catalog owner.

Note: In releases prior to 8.1.5, you created the recovery catalog schema by connecting to the recovery catalog database and executing the `catrman.sql` script.

See Also: Oracle Database Backup and Recovery Advanced User's Guide to learn how to create the recovery catalog

Restrictions and Usage Notes

- Execute this command only at the RMAN prompt.

- RMAN must be connected to the recovery catalog either through the `CATALOG` command-line option or the CONNECT `CATALOG` command, and the catalog database must be open. A connection to the target database is not required.

- The recovery catalog owner must be granted the `RECOVERY_CATALOG_OWNER` role, and also be granted space privileges in the tablespace where the recovery catalog tables will reside.

- If you specify the tablespace name in the `CREATE` `CATALOG` command, and if the tablespace name is an RMAN reserved word (as listed in "RMAN Reserved Words"), then it must be uppercase and enclosed in quotes.

- Do not create the recovery catalog in the `SYS` schema.

  See Also: Oracle Database Administrator's Guide for more information about the `RECOVERY_CATALOG_OWNER` role "cmdLine" for information about RMAN command-line options

Keywords and Parameters

None

Example

Creating a Catalog Schema: Example

The following example creates a user `rman`, grants `rman` the `RECOVERY_CATALOG_OWNER` role, then creates the recovery catalog in the schema `rman.cattbs` of the database `rcat`:

    #!/usr/bin/tcsh
    # create user rman in recovery catalog database as catalog owner
    % sqlplus 'SYS/change_on_install@rcat AS SYSDBA'
    SQL> CREATE USER rman IDENTIFIED BY rman
      DEFAULT TABLESPACE cattbs
      QUOTA UNLIMITED ON cattbs;
    SQL> GRANT recovery_catalog_owner TO rman;
    SQL> EXIT

    # connect to database as catalog owner and create catalog
    % rman CATALOG rman/rman@rcat
    RMAN> CREATE CATALOG;